import cryptography
import sqlalchemy
import pandas as pd
from sqlalchemy import create_engine
import  pymysql
print(sqlalchemy.__version__)
print(pymysql.__version__)
pymysql.install_as_MySQLdb()
df=pd.DataFrame({"班级":["一年级","二年级","三年级","四年级"],
                 "男生人数":[25,23,27,30],
                 "女生人数":[19,17,20,20]})
engine = create_engine('mysql+pymysql://root:123456@127.0.0.1:3306/students?charset=utf8mb4')
df.to_sql('students',con=engine,if_exists='replace',index=False)